	/****** Object: Table [dbo].[SECURITY_ROLE_GROUP_REL]   Script Date: 2015/2/26 17:44:22 ******/

CREATE TABLE [dbo].[SECURITY_ROLE_GROUP_REL] (
[GRP_ID] nvarchar(36) NOT NULL,
[ROLE_ID] nvarchar(36) NOT NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_USER_GROUP_REL]   Script Date: 2015/2/26 17:44:24 ******/

CREATE TABLE [dbo].[SECURITY_USER_GROUP_REL] (
[GRP_ID] nvarchar(36) NOT NULL,
[USER_ID] nvarchar(36) NOT NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_ROLE_AUTH]   Script Date: 2015/2/26 17:44:24 ******/

CREATE TABLE [dbo].[SECURITY_ROLE_AUTH] (
[ROLE_AUTH_ID] nvarchar(36) NOT NULL,
[ROLE_ID] nvarchar(36) NULL,
[RES_TYPE] nvarchar(32) NULL,
[RES_ID] nvarchar(36) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_USER_AUTH]   Script Date: 2015/2/26 17:44:24 ******/

CREATE TABLE [dbo].[SECURITY_USER_AUTH] (
[USER_AUTH_ID] nvarchar(36) NOT NULL,
[USER_ID] nvarchar(36) NULL,
[RES_TYPE] nvarchar(32) NULL,
[RES_ID] nvarchar(36) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SYS_CODELIST]   Script Date: 2015/2/26 17:44:24 ******/

CREATE TABLE [dbo].[SYS_CODELIST] (
[TYPE_ID] nvarchar(32) NOT NULL,
[CODE_ID] nvarchar(32) NOT NULL,
[CODE_NAME] nvarchar(32) NULL,
[CODE_DESC] nvarchar(128) NULL,
[CODE_SORT] int NULL,
[CODE_FLAG] nvarchar(32) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_USER_ROLE_REL]   Script Date: 2015/2/26 17:44:24 ******/

CREATE TABLE [dbo].[SECURITY_USER_ROLE_REL] (
[ROLE_ID] nvarchar(36) NOT NULL,
[USER_ID] nvarchar(36) NOT NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_USER]   Script Date: 2015/2/26 17:44:25 ******/

CREATE TABLE [dbo].[SECURITY_USER] (
[USER_ID] nvarchar(36) NOT NULL,
[USER_CODE] nvarchar(32) NULL,
[USER_NAME] nvarchar(32) NULL,
[USER_PWD] nvarchar(32) NULL,
[USER_SEX] nvarchar(1) NULL,
[USER_DESC] nvarchar(128) NULL,
[USER_STATE] nvarchar(32) NULL,
[USER_SORT] int NULL,
[USER_MAIL] nvarchar(64) NULL,
[USER_PHONE] nvarchar(64) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_GROUP_AUTH]   Script Date: 2015/2/26 17:44:26 ******/

CREATE TABLE [dbo].[SECURITY_GROUP_AUTH] (
[GRP_AUTH_ID] nvarchar(36) NOT NULL,
[GRP_ID] nvarchar(36) NULL,
[RES_TYPE] nvarchar(32) NULL,
[RES_ID] nvarchar(36) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_ROLE]   Script Date: 2015/2/26 17:44:26 ******/

CREATE TABLE [dbo].[SECURITY_ROLE] (
[ROLE_ID] nvarchar(36) NOT NULL,
[ROLE_CODE] nvarchar(32) NULL,
[ROLE_NAME] nvarchar(32) NULL,
[ROLE_PID] nvarchar(36) NULL,
[ROLE_DESC] nvarchar(128) NULL,
[ROLE_STATE] nvarchar(32) NULL,
[ROLE_SORT] int NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SECURITY_GROUP]   Script Date: 2015/2/26 17:44:26 ******/

CREATE TABLE [dbo].[SECURITY_GROUP] (
[GRP_ID] nvarchar(36) NOT NULL,
[GRP_CODE] nvarchar(32) NULL,
[GRP_NAME] nvarchar(32) NULL,
[GRP_PID] nvarchar(36) NULL,
[GRP_DESC] nvarchar(128) NULL,
[GRP_STATE] nvarchar(1) NULL,
[GRP_SORT] int NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SYS_CODETYPE]   Script Date: 2015/2/26 17:44:27 ******/

CREATE TABLE [dbo].[SYS_CODETYPE] (
[TYPE_ID] nvarchar(32) NOT NULL,
[TYPE_NAME] nvarchar(32) NULL,
[TYPE_GROUP] nvarchar(32) NULL,
[TYPE_DESC] nvarchar(128) NULL,
[IS_CACHED] nchar(1) NULL,
[IS_UNITEADMIN] nchar(1) NULL,
[IS_EDITABLE] nchar(1) NULL,
[LEGNTT_LIMIT] nvarchar(6) NULL,
[CHARACTER_LIMIT] nchar(1) NULL,
[EXTEND_SQL] nchar(1) NULL,
[SQL_BODY] nvarchar(512) NULL,
[SQL_COND] nvarchar(256) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SYS_LOG]   Script Date: 2015/2/26 17:44:29 ******/

CREATE TABLE [dbo].[SYS_LOG] (
[ID] nchar(36) NULL,
[OPER_TIME] datetime NOT NULL,
[IP_ADDTRESS] nvarchar(32) NULL,
[USER_ID] nvarchar(32) NULL,
[USER_NAME] nvarchar(32) NULL,
[FUNC_NAME] nvarchar(64) NULL,
[ACTION_TYPE] nvarchar(32) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[WCM_GENERAL_GROUP]   Script Date: 2015/2/26 17:44:30 ******/

CREATE TABLE [dbo].[WCM_GENERAL_GROUP] (
[GRP_ID] nvarchar(36) NOT NULL,
[GRP_NAME] nvarchar(64) NULL,
[GRP_PID] nvarchar(36) NULL,
[GRP_ORDERNO] int NULL,
[GRP_IS_SYSTEM] nvarchar(32) NULL,
[GRP_RES_TYPE_DESC] nvarchar(32) NULL,
[GRP_RES_TYPE_EXTS] nvarchar(128) NULL,
[GRP_RES_SIZE_LIMIT] nvarchar(32) NULL,
[GRP_DESC] nvarchar(128) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[WCM_GENERAL_RESOURCE]   Script Date: 2015/2/26 17:44:31 ******/

CREATE TABLE [dbo].[WCM_GENERAL_RESOURCE] (
[RES_ID] nvarchar(36) NOT NULL,
[GRP_ID] nvarchar(36) NULL,
[RES_NAME] nvarchar(64) NULL,
[RES_SHAREABLE] nvarchar(32) NULL,
[RES_LOCATION] nvarchar(256) NULL,
[RES_SIZE] nvarchar(64) NULL,
[RES_SUFFIX] nvarchar(32) NULL,
[RES_DESCRIPTION] nvarchar(256) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SYS_OPERATION]   Script Date: 2015/2/26 17:44:31 ******/

CREATE TABLE [dbo].[SYS_OPERATION] (
[OPER_ID] nchar(36) NOT NULL,
[HANLER_ID] nvarchar(36) NULL,
[OPER_CODE] nvarchar(64) NULL,
[OPER_NAME] nvarchar(64) NULL,
[OPER_ACTIONTPYE] nvarchar(64) NULL,
[OPER_SORT] int NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SYS_ONLINECOUNT]   Script Date: 2015/2/26 17:44:31 ******/

CREATE TABLE [dbo].[SYS_ONLINECOUNT] (
[IPADDRRESS] nvarchar(64) NOT NULL,
[ONLINECOUNT] int NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SYS_FUNCTION]   Script Date: 2015/2/26 17:44:31 ******/

CREATE TABLE [dbo].[SYS_FUNCTION] (
[FUNC_ID] nvarchar(36) NOT NULL,
[FUNC_NAME] nvarchar(64) NULL,
[FUNC_TYPE] nvarchar(32) NULL,
[MAIN_HANDLER] nvarchar(36) NULL,
[FUNC_PID] nvarchar(36) NULL,
[FUNC_STATE] nchar(1) NULL,
[FUNC_SORT] int NULL,
[FUNC_DESC] nvarchar(256) NULL)
ON [PRIMARY];

/****** Object: Table [dbo].[SYS_HANDLER]   Script Date: 2015/2/26 17:44:31 ******/

CREATE TABLE [dbo].[SYS_HANDLER] (
[HANLER_ID] nvarchar(36) NOT NULL,
[HANLER_CODE] nvarchar(64) NULL,
[HANLER_TYPE] nvarchar(32) NULL,
[HANLER_URL] nvarchar(128) NULL,
[FUNC_ID] nvarchar(36) NULL)
ON [PRIMARY];


INSERT INTO [dbo].[SECURITY_GROUP] ([GRP_ID], [GRP_CODE], [GRP_NAME], [GRP_PID], [GRP_DESC], [GRP_STATE], [GRP_SORT])
VALUES (N'00000000-0000-0000-00000000000000000', N'Root', N'公司集团', NULL, NULL, N'1', 0);

INSERT INTO [dbo].[SECURITY_GROUP] ([GRP_ID], [GRP_CODE], [GRP_NAME], [GRP_PID], [GRP_DESC], [GRP_STATE], [GRP_SORT])
VALUES (N'B6F11BD3-DE55-4F14-A400-540B9E4F45F3', N'IT', N'信息部', N'00000000-0000-0000-00000000000000000', N'', N'1', 2);

INSERT INTO [dbo].[SECURITY_GROUP_AUTH] ([GRP_AUTH_ID], [GRP_ID], [RES_TYPE], [RES_ID])
VALUES (N'4C20EDAC-0A0B-45BB-8B71-B557A94E7429', N'B6F11BD3-DE55-4F14-A400-540B9E4F45F3', N'Navigater', N'02');

INSERT INTO [dbo].[SECURITY_ROLE] ([ROLE_ID], [ROLE_CODE], [ROLE_NAME], [ROLE_PID], [ROLE_DESC], [ROLE_STATE], [ROLE_SORT])
VALUES (N'00000000-0000-0000-00000000000000000', N'System', N'系统角色', NULL, NULL, N'1', NULL);

INSERT INTO [dbo].[SECURITY_ROLE] ([ROLE_ID], [ROLE_CODE], [ROLE_NAME], [ROLE_PID], [ROLE_DESC], [ROLE_STATE], [ROLE_SORT])
VALUES (N'8752C789-44BD-4941-AEF1-B9CC8B5C3CC6', N'ITManager', N'IT主管', N'00000000-0000-0000-00000000000000000', N'', N'1', 3);

INSERT INTO [dbo].[SECURITY_ROLE_AUTH] ([ROLE_AUTH_ID], [ROLE_ID], [RES_TYPE], [RES_ID])
VALUES (N'586BF6FA-4066-4C65-9352-C0A17B6E2170', N'8752C789-44BD-4941-AEF1-B9CC8B5C3CC6', N'Menu', N'00000000-0000-0000-00000000000000000');

INSERT INTO [dbo].[SECURITY_ROLE_AUTH] ([ROLE_AUTH_ID], [ROLE_ID], [RES_TYPE], [RES_ID])
VALUES (N'702F8D06-7AF5-4931-8F96-5B4A69D9D2E5', N'8752C789-44BD-4941-AEF1-B9CC8B5C3CC6', N'Menu', N'AD5188DB-BF4F-4CFB-853E-8CA469D3E477');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'00000000-0000-0000-00000000000000000', N'00000000-0000-0000-00000000000000000');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'21E50836-912E-4DB8-82CB-9B32C8A44C9F', N'00000000-0000-0000-00000000000000000');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'21E50836-912E-4DB8-82CB-9B32C8A44C9F', N'25788B54-CE0A-4137-8890-EFA4F0DE06B6');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'23F5915B-C8F1-4BA5-AED9-7CE50B11D5F4', N'00000000-0000-0000-00000000000000000');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'23F5915B-C8F1-4BA5-AED9-7CE50B11D5F4', N'25788B54-CE0A-4137-8890-EFA4F0DE06B6');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'315F898C-A008-4F77-BAB0-4FDF935F7B1F', N'00000000-0000-0000-00000000000000000');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'315F898C-A008-4F77-BAB0-4FDF935F7B1F', N'25788B54-CE0A-4137-8890-EFA4F0DE06B6');

INSERT INTO [dbo].[SECURITY_ROLE_GROUP_REL] ([GRP_ID], [ROLE_ID])
VALUES (N'BBD420A2-68AE-49C2-B3D8-78DC166F511F', N'00000000-0000-0000-00000000000000000');

INSERT INTO [dbo].[SECURITY_USER] ([USER_ID], [USER_CODE], [USER_NAME], [USER_PWD], [USER_SEX], [USER_DESC], [USER_STATE], [USER_SORT], [USER_MAIL], [USER_PHONE])
VALUES (N'7DE6ED51-3F4B-4BE6-84A6-17BC6186CC24', N'admin', N'管理员', N'21232F297A57A5A743894A0E4A801FC3', N'M', N'内置账户，勿删！！', N'1', 1, NULL, NULL);

INSERT INTO [dbo].[SECURITY_USER] ([USER_ID], [USER_CODE], [USER_NAME], [USER_PWD], [USER_SEX], [USER_DESC], [USER_STATE], [USER_SORT], [USER_MAIL], [USER_PHONE])
VALUES (N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC', N'user', N'默认用户', N'EE11CBB19052E40B07AAC0CA060C23EE', N'M', N'默认内置用户，勿删！！', N'1', 2, NULL, NULL);

INSERT INTO [dbo].[SECURITY_USER_AUTH] ([USER_AUTH_ID], [USER_ID], [RES_TYPE], [RES_ID])
VALUES (N'1279D0FE-B366-4D7E-9C99-B6B3424387F3', N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC', N'Menu', N'00000000-0000-0000-00000000000000000');

INSERT INTO [dbo].[SECURITY_USER_AUTH] ([USER_AUTH_ID], [USER_ID], [RES_TYPE], [RES_ID])
VALUES (N'5194F17D-B001-44EE-9FAB-21F836CB49A8', N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC', N'Handler', N'494DF09B-7573-4CCA-85C1-97F4DC58C86B');

INSERT INTO [dbo].[SECURITY_USER_AUTH] ([USER_AUTH_ID], [USER_ID], [RES_TYPE], [RES_ID])
VALUES (N'63253005-BECA-4C51-A764-C36342DA009F', N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC', N'Menu', N'00000000-0000-0000-00000000000000001');

INSERT INTO [dbo].[SECURITY_USER_AUTH] ([USER_AUTH_ID], [USER_ID], [RES_TYPE], [RES_ID])
VALUES (N'97F07CAD-F046-48FB-B03B-5A0AA049FBD5', N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC', N'Menu', N'67BA273A-DD31-48D0-B78C-1D60D5316074');

INSERT INTO [dbo].[SECURITY_USER_AUTH] ([USER_AUTH_ID], [USER_ID], [RES_TYPE], [RES_ID])
VALUES (N'D76FA80F-51AB-4A5B-9594-6DAE53A3C1E3', N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC', N'Operation', N'3EC41FB8-ED98-41F3-B86D-F7473AEDD002');

INSERT INTO [dbo].[SECURITY_USER_GROUP_REL] ([GRP_ID], [USER_ID])
VALUES (N'00000000-0000-0000-00000000000000000', N'7DE6ED51-3F4B-4BE6-84A6-17BC6186CC24');

INSERT INTO [dbo].[SECURITY_USER_GROUP_REL] ([GRP_ID], [USER_ID])
VALUES (N'B6F11BD3-DE55-4F14-A400-540B9E4F45F3', N'9A0A9DE7-608A-4B2B-B1C7-F6C11FD1A94E');

INSERT INTO [dbo].[SECURITY_USER_GROUP_REL] ([GRP_ID], [USER_ID])
VALUES (N'B6F11BD3-DE55-4F14-A400-540B9E4F45F3', N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'00000000-0000-0000-00000000000000000', N'01355EDD-C556-4003-AFCE-0E777D4C2776');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'00000000-0000-0000-00000000000000000', N'3C927795-572A-4478-871E-5AC72C165BCB');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'00000000-0000-0000-00000000000000000', N'6A4BD4CD-5A31-4510-A4D0-A227C0CECA93');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'00000000-0000-0000-00000000000000000', N'F1580191-F60D-438E-9B59-3C1E491E9E78');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'8752C789-44BD-4941-AEF1-B9CC8B5C3CC6', N'0098122C-C06E-4316-85B7-54C2646329AF');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'8752C789-44BD-4941-AEF1-B9CC8B5C3CC6', N'7DE6ED51-3F4B-4BE6-84A6-17BC6186CC24');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'8752C789-44BD-4941-AEF1-B9CC8B5C3CC6', N'B64DCBC3-F28A-4DC8-92F1-1FB10367CACC');

INSERT INTO [dbo].[SECURITY_USER_ROLE_REL] ([ROLE_ID], [USER_ID])
VALUES (N'D4094F0E-8087-4AAD-A957-01797000BB42', N'CDADE387-273C-45D0-8858-8AC0050DC78E');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'BOOL_DEFINE', N'N', N'否', N'', 2, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'BOOL_DEFINE', N'Y', N'是', N'', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'CODE_TYPE_GROUP', N'app_code_define', N'应用编码', N'null', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'CODE_TYPE_GROUP', N'sys_code_define', N'系统编码', N'系统编码123a1', 3, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'FUNCTION_TYPE', N'funcmenu', N'功能菜单', N'', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'FUNCTION_TYPE', N'funcnode', N'功能节点', N'', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'HANDLER_TYPE', N'MAIN', N'主处理器', N'', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'HANDLER_TYPE', N'OTHER', N'其他处理器', N'', 2, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'MENUTREE_CASCADE', N'0', N'关闭', N'', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'MENUTREE_CASCADE', N'1', N'展开', N'', 2, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'OPER_CTR_TYPE', N'disableMode', N'不能操作', N'', 2, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'OPER_CTR_TYPE', N'hiddenMode', N'隐藏按钮', N'', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'POSITION_TYPE', N'dummy_postion', N'虚拟岗位', N'null', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'POSITION_TYPE', N'real_postion', N'实际岗位', N'null', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'RES_TYPE', N'IMAGE', N'图片文件', N'', 2, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'RES_TYPE', N'ISO', N'镜像文件', N'', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'RES_TYPE', N'VIDEO', N'视频文件', N'', 3, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'SYS_VALID_TYPE', N'0', N'无效', N'null', 2, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'SYS_VALID_TYPE', N'1', N'有效', N'null', 1, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'UNIT_TYPE', N'dept', N'部门', N'', 10, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'UNIT_TYPE', N'org', N'机构', N'', 20, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'UNIT_TYPE', N'post', N'岗位', N'', 30, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'USER_SEX', N'F', N'女', N'', 2, N'1');

INSERT INTO [dbo].[SYS_CODELIST] ([TYPE_ID], [CODE_ID], [CODE_NAME], [CODE_DESC], [CODE_SORT], [CODE_FLAG])
VALUES (N'USER_SEX', N'M', N'男', N'null', 1, N'1');

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'BOOL_DEFINE', N'布尔定义', N'sys_code_define', N'', N'Y', N'Y', N'Y', N'1', N'C', N' ', N'', N'');

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'CODE_TYPE_GROUP', N'编码类型分组', N'app_code_define', N'编码类型分组', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'FUNCTION_TYPE', N'功能类型', N'sys_code_define', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'HANDLER_TYPE', N'控制器类型', N'sys_code_define', N'', N'N', N'Y', N'Y', N'32', N'C', NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'MENUTREE_CASCADE', N'是否展开', N'sys_code_define', N'', N'Y', N'Y', N'Y', N'1', N'N', N'N', N'', N'');

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'OPER_CTR_TYPE', N'操作控制类型', N'sys_code_define', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'POSITION_TYPE', N'岗位类型', N'app_code_define', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'RES_TYPE', N'资源类型', N'sys_code_define', N'', N'N', N'Y', N'Y', N'16', N'C', NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'SYS_VALID_TYPE', N'有效标识符', N'app_code_define', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'UNIT_TYPE', N'单位类型', N'app_code_define', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_CODETYPE] ([TYPE_ID], [TYPE_NAME], [TYPE_GROUP], [TYPE_DESC], [IS_CACHED], [IS_UNITEADMIN], [IS_EDITABLE], [LEGNTT_LIMIT], [CHARACTER_LIMIT], [EXTEND_SQL], [SQL_BODY], [SQL_COND])
VALUES (N'USER_SEX', N'性别类型', N'sys_code_define', N'', N'N', N'Y', N'Y', N'16', N'C', NULL, NULL, NULL);

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'00000000-0000-0000-00000000000000000', N'Miscdp样例系统', N'funcmenu', NULL, NULL, N'1', NULL, NULL);

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'00000000-0000-0000-00000000000000001', N'系统管理', N'funcmenu', N'', N'00000000-0000-0000-00000000000000000', N'1', 99, N'');

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'0855A94F-F8E0-42D6-A0DF-72F1D11C6D0B', N'投票管理', N'funcnode', N'87D4B614-DF7E-48D2-BA04-3A31728740D9', N'AD5188DB-BF4F-4CFB-853E-8CA469D3E477', N'1', 3, N'');

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'2F0F133F-1A6F-4E01-AADD-5B11C97BE6A0', N'资源管理', N'funcnode', N'6479AF01-D00B-4A40-B502-98FAF8418E92', N'AD5188DB-BF4F-4CFB-853E-8CA469D3E477', N'1', 5, N'');

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'36954650-E79A-4682-8AC2-D3A78461A3D4', N'资源分组', N'funcnode', N'0543DD98-8AE6-4DF1-990E-24CD51E73564', N'AD5188DB-BF4F-4CFB-853E-8CA469D3E477', N'1', 4, N'');

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'5FDEE3AB-6D32-4C5F-AD65-EF1EE5FFBAE6', N'附件管理', N'funcnode', N'1F617665-FC8B-4E8C-ABE4-540C363A17A8', N'00000000-0000-0000-00000000000000001', N'1', 7, N'');

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'67BA273A-DD31-48D0-B78C-1D60D5316074', N'系统日志', N'funcnode', N'494DF09B-7573-4CCA-85C1-97F4DC58C86B', N'00000000-0000-0000-00000000000000001', N'1', 6, NULL);

INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'692B0D37-2E66-4E82-92B4-E59BCF76EE76', N'编码管理', N'funcnode', N'B4FE5722-9EA6-47D8-8770-D999A3F6A354', N'00000000-0000-0000-00000000000000001', N'1', 5, NULL);
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'72D2FDBA-6400-4C48-A462-BA5E5B996631', N'账户查询', N'funcnode', N'6BA56996-4F31-464F-B230-A7E764CCC547', N'AD5188DB-BF4F-4CFB-853E-8CA469D3E477', N'1', 2, N'');
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'8C84B439-2788-4608-89C4-8F5AA076D124', N'组织机构', N'funcnode', N'439949F0-C6B7-49FF-8ED1-2A1B5062E7B9', N'00000000-0000-0000-00000000000000001', N'1', 1, NULL);
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'A0334956-426E-4E49-831B-EB00E37285FD', N'编码类型', N'funcnode', N'9A16D554-F989-438A-B92D-C8C8AC6BF9B8', N'00000000-0000-0000-00000000000000001', N'1', 4, NULL);
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'AD5188DB-BF4F-4CFB-853E-8CA469D3E477', N'样例功能', N'funcmenu', N'', N'00000000-0000-0000-00000000000000000', N'1', 100, N'');
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'C843A0B6-2837-48A6-9C16-DCB6FFB37790', N'账户管理', N'funcnode', N'048E2C48-1BD4-4EB2-94E4-208835D302EB', N'AD5188DB-BF4F-4CFB-853E-8CA469D3E477', N'1', 1, N'');
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'C977BC31-C78F-4B16-B0C6-769783E46A06', N'功能管理', N'funcnode', N'46C52D33-8797-4251-951F-F7CA23C76BD7', N'00000000-0000-0000-00000000000000001', N'1', 3, NULL);
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'D3582A2A-3173-4F92-B1AD-2F999A2CBE18', N'修改密码', N'funcnode', N'88882DB9-967F-430E-BA9C-D0BBBBD2BD0C', N'00000000-0000-0000-00000000000000001', N'1', 8, N'');
INSERT INTO [dbo].[SYS_FUNCTION] ([FUNC_ID], [FUNC_NAME], [FUNC_TYPE], [MAIN_HANDLER], [FUNC_PID], [FUNC_STATE], [FUNC_SORT], [FUNC_DESC])
VALUES (N'DFE8BE4C-4024-4A7B-8DF2-630003832AE9', N'角色管理', N'funcnode', N'0CE03AD4-FF29-4FDB-8FEE-DA8AA38B649F', N'00000000-0000-0000-00000000000000001', N'1', 2, NULL);

INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'048E2C48-1BD4-4EB2-94E4-208835D302EB', N'AccountManageList', N'MAIN', NULL, N'C843A0B6-2837-48A6-9C16-DCB6FFB37790');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'0543DD98-8AE6-4DF1-990E-24CD51E73564', N'ResGroupTreeManage', N'MAIN', NULL, N'36954650-E79A-4682-8AC2-D3A78461A3D4');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'0CE03AD4-FF29-4FDB-8FEE-DA8AA38B649F', N'SecurityRoleTreeManage', N'MAIN', N'', N'DFE8BE4C-4024-4A7B-8DF2-630003832AE9');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'1F617665-FC8B-4E8C-ABE4-540C363A17A8', N'WcmGeneralGroup8ContentList', N'MAIN', NULL, N'5FDEE3AB-6D32-4C5F-AD65-EF1EE5FFBAE6');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'439949F0-C6B7-49FF-8ED1-2A1B5062E7B9', N'SecurityGroupList', N'MAIN', N'', N'8C84B439-2788-4608-89C4-8F5AA076D124');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'46C52D33-8797-4251-951F-F7CA23C76BD7', N'FunctionTreeManage', N'MAIN', NULL, N'C977BC31-C78F-4B16-B0C6-769783E46A06');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'494DF09B-7573-4CCA-85C1-97F4DC58C86B', N'SysLogQueryList', N'MAIN', NULL, N'67BA273A-DD31-48D0-B78C-1D60D5316074');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'6479AF01-D00B-4A40-B502-98FAF8418E92', N'ResGroup8ContentList', N'MAIN', NULL, N'2F0F133F-1A6F-4E01-AADD-5B11C97BE6A0');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'6BA56996-4F31-464F-B230-A7E764CCC547', N'AccountQueryList', N'MAIN', NULL, N'72D2FDBA-6400-4C48-A462-BA5E5B996631');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'87D4B614-DF7E-48D2-BA04-3A31728740D9', N'VoteInfoManageList', N'MAIN', NULL, N'0855A94F-F8E0-42D6-A0DF-72F1D11C6D0B');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'88882DB9-967F-430E-BA9C-D0BBBBD2BD0C', N'ModifyPassword', N'MAIN', NULL, N'D3582A2A-3173-4F92-B1AD-2F999A2CBE18');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'9A16D554-F989-438A-B92D-C8C8AC6BF9B8', N'CodeTypeManageList', N'MAIN', NULL, N'A0334956-426E-4E49-831B-EB00E37285FD');
INSERT INTO [dbo].[SYS_HANDLER] ([HANLER_ID], [HANLER_CODE], [HANLER_TYPE], [HANLER_URL], [FUNC_ID])
VALUES (N'B4FE5722-9EA6-47D8-8770-D999A3F6A354', N'CodeListManageList', N'MAIN', NULL, N'692B0D37-2E66-4E82-92B4-E59BCF76EE76');

INSERT INTO [dbo].[SYS_LOG] ([ID], [OPER_TIME], [IP_ADDTRESS], [USER_ID], [USER_NAME], [FUNC_NAME], [ACTION_TYPE])
VALUES (N'50158899-1D9A-4F02-B3ED-588A5983FEB5', '2015-02-25T16:53:14', N'127.0.0.1', N'admin', N'管理员', N'系统登陆', N'login');
INSERT INTO [dbo].[SYS_LOG] ([ID], [OPER_TIME], [IP_ADDTRESS], [USER_ID], [USER_NAME], [FUNC_NAME], [ACTION_TYPE])
VALUES (N'9C0E8965-2355-4224-92EC-8C0F432FC8B9', '2015-02-25T17:43:35', N'127.0.0.1', N'admin', N'管理员', N'系统登陆', N'login');
INSERT INTO [dbo].[SYS_LOG] ([ID], [OPER_TIME], [IP_ADDTRESS], [USER_ID], [USER_NAME], [FUNC_NAME], [ACTION_TYPE])
VALUES (N'5A098FEE-3FA0-4595-8839-E8844B130259', '2015-02-25T17:44:27', N'127.0.0.1', N'admin', N'管理员', N'系统登陆', N'login');


INSERT INTO [dbo].[SYS_OPERATION] ([OPER_ID], [HANLER_ID], [OPER_CODE], [OPER_NAME], [OPER_ACTIONTPYE], [OPER_SORT])
VALUES (N'3EC41FB8-ED98-41F3-B86D-F7473AEDD002', N'494DF09B-7573-4CCA-85C1-97F4DC58C86B', N'viewDetail', N'查看', N'viewDetail', 1);
INSERT INTO [dbo].[SYS_OPERATION] ([OPER_ID], [HANLER_ID], [OPER_CODE], [OPER_NAME], [OPER_ACTIONTPYE], [OPER_SORT])
VALUES (N'6BF7A157-D333-4F40-8612-F61D3FD4D258', N'494DF09B-7573-4CCA-85C1-97F4DC58C86B', N'refreshImgBtn', N'刷新', N'refresh', 2);

INSERT INTO [dbo].[WCM_GENERAL_GROUP] ([GRP_ID], [GRP_NAME], [GRP_PID], [GRP_ORDERNO], [GRP_IS_SYSTEM], [GRP_RES_TYPE_DESC], [GRP_RES_TYPE_EXTS], [GRP_RES_SIZE_LIMIT], [GRP_DESC])
VALUES (N'77777777-7777-7777-7777-777777777777', N'附件目录', N'', NULL, N'', N'', N'', N'', N'');
INSERT INTO [dbo].[WCM_GENERAL_GROUP] ([GRP_ID], [GRP_NAME], [GRP_PID], [GRP_ORDERNO], [GRP_IS_SYSTEM], [GRP_RES_TYPE_DESC], [GRP_RES_TYPE_EXTS], [GRP_RES_SIZE_LIMIT], [GRP_DESC])
VALUES (N'A6018D88-8345-46EE-A452-CE362FAC72E2', N'视频文件', N'77777777-7777-7777-7777-777777777777', 1, N'Y', N'视频', N'*.mp4;*.3gp;*.wmv;*.avi;*.rm;*.rmvb;*.flv', N'100MB', N'');
INSERT INTO [dbo].[WCM_GENERAL_GROUP] ([GRP_ID], [GRP_NAME], [GRP_PID], [GRP_ORDERNO], [GRP_IS_SYSTEM], [GRP_RES_TYPE_DESC], [GRP_RES_TYPE_EXTS], [GRP_RES_SIZE_LIMIT], [GRP_DESC])
VALUES (N'CF35D1E6-102E-428A-B39C-0072D491D5B1', N'业务附件', N'77777777-7777-7777-7777-777777777777', 2, N'Y', N'所有资源', N'*.*', N'2MB', N'');


ALTER TABLE [dbo].[SECURITY_GROUP] ADD PRIMARY KEY ([GRP_ID]);

ALTER TABLE [dbo].[SECURITY_GROUP_AUTH] ADD PRIMARY KEY ([GRP_AUTH_ID]);

ALTER TABLE [dbo].[SECURITY_ROLE] ADD PRIMARY KEY ([ROLE_ID]);

ALTER TABLE [dbo].[SECURITY_ROLE_AUTH] ADD PRIMARY KEY ([ROLE_AUTH_ID]);

ALTER TABLE [dbo].[SECURITY_ROLE_GROUP_REL] ADD PRIMARY KEY ([GRP_ID], [ROLE_ID]);

ALTER TABLE [dbo].[SECURITY_USER] ADD PRIMARY KEY ([USER_ID]);

ALTER TABLE [dbo].[SECURITY_USER_AUTH] ADD PRIMARY KEY ([USER_AUTH_ID]);

ALTER TABLE [dbo].[SECURITY_USER_GROUP_REL] ADD PRIMARY KEY ([GRP_ID], [USER_ID]);

ALTER TABLE [dbo].[SECURITY_USER_ROLE_REL] ADD PRIMARY KEY ([ROLE_ID], [USER_ID]);

ALTER TABLE [dbo].[SYS_CODELIST] ADD PRIMARY KEY ([TYPE_ID], [CODE_ID]);

ALTER TABLE [dbo].[SYS_CODETYPE] ADD PRIMARY KEY ([TYPE_ID]);

ALTER TABLE [dbo].[SYS_FUNCTION] ADD PRIMARY KEY ([FUNC_ID]);

ALTER TABLE [dbo].[SYS_HANDLER] ADD PRIMARY KEY ([HANLER_ID]);

ALTER TABLE [dbo].[SYS_ONLINECOUNT] ADD PRIMARY KEY ([IPADDRRESS]);

ALTER TABLE [dbo].[SYS_OPERATION] ADD PRIMARY KEY ([OPER_ID]);

ALTER TABLE [dbo].[WCM_GENERAL_GROUP] ADD PRIMARY KEY ([GRP_ID]);

ALTER TABLE [dbo].[WCM_GENERAL_RESOURCE] ADD PRIMARY KEY ([RES_ID]);

